#include <stdio.h>
#include <string.h>
#include <mysql/mysql.h>
void delete_3(MYSQL *mysql){
	printf("        删除选课表数据        \n"); 	
	char delete_data[200];
	char name[50];
	int f=0;                                                          
	printf("删除该学生的选课信息:输入该学生的姓名:");                             
	scanf("%s",name);                                                         
	sprintf(delete_data,"delete from stusub where stid=(select stid from student where name='%s')",name);             
	f = mysql_real_query(mysql, delete_data, strlen(delete_data));         
	if (0 != f) {                                                           
		printf("删除该学生选课信息失败!\n");         
	}
}
